//Copyright (c) 2012, peter.ducai@gmail.com
//All rights reserved.
//
//Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following 
//conditions are met:
//
//Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
//Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer
//in the documentation and/or other materials provided with the distribution.
//THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,
//INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
//IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY,
//OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA,
//OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
//OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY
//OF SUCH DAMAGE.
package com.daemonna.fluentlee_core.database;

import com.daemonna.fluentlee_core.objects.connector;
import com.daemonna.fluentlee_core.pools.schedule_pool;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;

/*
 * @author peter 'daemonna' ducai @author peter.ducai@gmail.com @author
 * http://code.google.com/p/fluentlee/
 */
public class db_derby implements db_manager {

    public enum status {

        INNACTIVE, ACTIVE, CLOSED
    }
    Statement stmt;
    Connection conn;
    ResultSet rset;
    public status db_status = status.INNACTIVE;

    @Override
    public void init_db(connector con) {


        if (db_status != status.ACTIVE) {
            db_status = status.ACTIVE;
            try {
                Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
                conn = DriverManager.getConnection(con.url);
            } catch (SQLException ex) {
                Logger.getLogger(db_derby.class.getName()).log(Level.SEVERE, null, ex);
            } catch (ClassNotFoundException ex) {
                Logger.getLogger(db_derby.class.getName()).log(Level.SEVERE, null, ex);
            }

        }
    }

    @Override
    public void execute_sql(String some_sql) {
        try {
            conn.setAutoCommit(false);
            stmt = conn.createStatement();
            stmt.execute(some_sql);
            stmt.close();
        } catch (SQLException ex) {
            Logger.getLogger(db_oracle.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    @Override
    public ResultSet execute_sql_query(String some_sql, int sched_index, int x, int v) {
        try {
            conn.setAutoCommit(true);
            stmt = conn.createStatement();
            schedule_pool.getInstance().scheds[sched_index].suites[x].jobs[v].sql_resultset = stmt.executeQuery(some_sql);
            while (schedule_pool.getInstance().scheds[sched_index].suites[x].jobs[v].sql_resultset.next()) {
                //System.out.println(rset.getInt(1));
            }
        } catch (SQLException ex) {
            Logger.getLogger(db_oracle.class.getName()).log(Level.SEVERE, null, ex);
        }
        return rset;
    }

    @Override
    public void execute_file(String path_to_sql_file) {
        throw new UnsupportedOperationException("Not supported yet.");
    }

    @Override
    public void close_db() {
        throw new UnsupportedOperationException("Not supported yet.");
    }
}
